// 
// Entify project
//  
// Author:
//       Lauri Taimila <lauri@taimila.com>
// 
// Copyright (c) 2010 Lauri Taimila
// 
// Permission is hereby granted, free of charge, to any person obtaining a copy
// of this software and associated documentation files (the "Software"), to deal
// in the Software without restriction, including without limitation the rights
// to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
// copies of the Software, and to permit persons to whom the Software is
// furnished to do so, subject to the following conditions:
// 
// The above copyright notice and this permission notice shall be included in
// all copies or substantial portions of the Software.
// 
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
// IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
// FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
// AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
// LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
// OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
// THE SOFTWARE.

using Mono.Data.Sqlite;

namespace Taimila.Entify.Sqlite
{
	/// <summary>
	/// This class contains extension methods for type SqliteCommand.
	/// </summary>
	internal static class SqliteCommandExtensions
	{
		/// <summary>
		/// Get complete SQL query with parameter values in place.
		/// </summary>
		/// <param name="command">
		/// Object to be extended. <see cref="SqliteCommand"/>
		/// </param>
		/// <returns>
		/// SQL Query with parameter values in place. <see cref="System.String"/>
		/// </returns>
		public static string GetQuery(this SqliteCommand command)
		{
			string query = command.CommandText;
			
			for(int i = command.Parameters.Count - 1 ; i >= 0 ; i--)
			{
				query = query.Replace(command.Parameters[i].ParameterName, "" + command.Parameters[i].Value);
			}

			return query;
		}
	}
}
